USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Employee_Create]    Script Date: 02/10/2012 11:28:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Employee_Create]	
	@Username		VARCHAR(50),
	@Password	    VARCHAR(100),
	@FullName		NVARCHAR(125),
	@Address		NVARCHAR(225),
	@Email			NVARCHAR(100),
	@Note			NVARCHAR(225),
	@RoleID			BIGINT,
	@RightsValue	BIGINT,
	@CMND			VARCHAR(20),	
	@DOB			VARCHAR(50),
	@IsActive		BIT,
	@PhoneNumber	VARCHAR(15),
	@TotalDebt		BIGINT
AS
BEGIN
	INSERT INTO Employee 
			(Username, Password, FullName, Address, Email, Note, RoleID, RightsValue, CMND, DOB, IsActive, PhoneNumber, TotalDebt)
	VALUES	(@Username, @Password, @FullName, @Address, @Email, @Note, @RoleID, @RightsValue, @CMND, @DOB, @IsActive, @PhoneNumber, @TotalDebt)	
END

GO

